LOAD DATA
TRUNCATE 
INTO TABLE gex_bdebdu_posd_tb
TRAILING NULLCOLS 
(line_no                	SEQUENCE(MAX)
,date_prod			POSITION(1:11)		"TO_DATE(:date_prod,'YYYY/MM/DD')"                      
,cd_portef			POSITION(12:27)		CHAR 
,cd_division			POSITION(28:39) 	CHAR
,cd_direction			POSITION(40:52) 	CHAR    
,cd_activite			POSITION(53:64)		CHAR
,cd_mode_gestion 		POSITION(65:80) 	CHAR
,cd_classe_actif		POSITION(81:96)		CHAR
,cd_type_gestion		POSITION(97:112)        CHAR
,cd_indice_comparaison		POSITION(113:134)	CHAR
,nom_portef			POSITION(135:150)   	CHAR
,provenance            		POSITION(151:161)	CHAR
,quantite         		POSITION(162:180)	"TO_NUMBER(:quantite,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_local    	POSITION(181:202)	"TO_NUMBER(:valeur_cout_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_cad      	POSITION(203:222)	"TO_NUMBER(:valeur_cout_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_dev_usd      	POSITION(223:242)	"TO_NUMBER(:valeur_cout_dev_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_cout_amort_dec_cad	POSITION(243:269)	"TO_NUMBER(:valeur_cout_amort_dec_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_local  	POSITION(270:292)	"TO_NUMBER(:valeur_march_unit_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_cad 		POSITION(293:314)	"TO_NUMBER(:valeur_march_unit_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_unit_usd 		POSITION(315:336)	"TO_NUMBER(:valeur_march_unit_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_local		POSITION(337:359)	"TO_NUMBER(:valeur_march_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_cad  		POSITION(360:380)	"TO_NUMBER(:valeur_march_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,valeur_march_dev_usd  		POSITION(381:401)	"TO_NUMBER(:valeur_march_dev_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
--,ai_dev_local          		POSITION(402:420)	"DECODE(TRIM(:ai_dev_local),'NULL',null,TO_NUMBER(:ai_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. '''))" 
--,ai_dev_cad            		POSITION(421:439)	"DECODE(TRIM(:ai_dev_cad),'NULL',null,TO_NUMBER(:ai_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. '''))"
,vm_ai_dev_local       		POSITION(402:420)	"TO_NUMBER(:vm_ai_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,vm_ai_cad       		POSITION(421:439)	"TO_NUMBER(:vm_ai_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"	
,vm_ai_usd       		POSITION(440:458)	"TO_NUMBER(:vm_ai_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,cusip     			POSITION(459:471)	CHAR
,type_identifiant  		POSITION(472:511)	CHAR
,id_titre			POSITION(512:523)	"TRIM(:id_titre)"
,date_emission                 	POSITION(524:537)	"TO_DATE(:date_emission,'YYYY/MM/DD')"
--,numero_transaction    		POSITION(459:515)	"DECODE(TRIM(:numero_transaction),'NULL',null,TO_NUMBER(:numero_transaction))"
--,id_gen  				POSITION(478:537)	"DECODE(TRIM(:id_gen),'NULL',null,:id_gen)"
--,repo_rate                     	POSITION(497:552)	"DECODE(TRIM(:repo_rate),'NULL',null,ROUND(TO_NUMBER(:repo_rate,'9D99999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),6))"
,taux_int_nominal              	POSITION(538:558)	"ROUND(TO_NUMBER(:taux_int_nominal,'999D99999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),6)"
,mature_date                   	POSITION(559:570)	"TO_DATE(:mature_date,'YYYY/MM/DD')"      
,titre     			POSITION(571:586)	CHAR
,cd_titre			POSITION(587:602)	CHAR
,cd_devise			POSITION(603:612)	CHAR
,article_loi     		POSITION(613:628)	CHAR
,indicat_vote  			POSITION(629:644)	CHAR
,nb_droit_vote     		POSITION(645:665)	"ROUND(TO_NUMBER(:nb_droit_vote,'999999D9999999999999999999','NLS_NUMERIC_CHARACTERS=''. '''),1)"
,cd_indice_primaire   		POSITION(666:684)	CHAR
,cd_autre_indice       		POSITION(685:700)	CHAR
,cd_autre_sect         		POSITION(701:714)	CHAR
,cd_autre_sous_sect    		POSITION(715:733)	CHAR
,cd_secteur_cig        		POSITION(734:749)	CHAR
,cd_gr_industrie_cig   		POSITION(750:769)	CHAR
,cd_industrie_cig      		POSITION(770:786)	CHAR
,cd_sous_industrie_cig 		POSITION(787:808)	CHAR
,cd_indice_ref         		POSITION(809:822)	CHAR
,cd_sect_ref           		POSITION(823:834)	CHAR
,cd_sous_sect_ref      		POSITION(835:851)	CHAR
,cd_industrie_ref      		POSITION(852:868)	CHAR
,cd_sous_industrie_ref 		POSITION(869:890)	CHAR
,cd_dernier_niveau_ref 		POSITION(891:912)	CHAR
,cd_secteur_cig2       		POSITION(913:928)	CHAR
,cd_sous_secteur_cig2  		POSITION(929:949)	CHAR
,cd_origine_geo        		POSITION(950:964)	CHAR
,quant_emise     		POSITION(965:983)	"TO_NUMBER(:quant_emise,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,descr_titre     		POSITION(984:1023)	CHAR
,cd_emetteur			POSITION(1024:1035)	CHAR
,cd_pays_emetteur_iso  		POSITION(1036:1056)	CHAR
,cd_pays_titre       		POSITION(1057:1072)	CHAR
,cd_categ_gen_plac     		POSITION(1073:1090)	CHAR
,cd_type_instrument    		POSITION(1091:1109)	CHAR
,freq_coupon           		POSITION(1110:1121)	CHAR
,cd_type_emission      		POSITION(1122:1138)	CHAR
,cd_classe_emission    		POSITION(1139:1157)	CHAR
,performance_class     		POSITION(1158:1175)	CHAR
)